Exact Financials

Connectivity Manual - IFALL - Project forecasts

Project forecasts

As of version 3.23 it is possible to import project forecasts via EDIS. The definition used for project budgets is also used for project forecasts. The following values should be used for "Change_type" to import forecasts:

403003: Actual forecast
403004: Estimate to complete
403005: Percentage completed

The fields "Date_change" and "Reason" are ignored for project forecasts.

Forecast per cost category (PRRCCA)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	COST_CAT_CODE	Character	8	prccat	Cost category	-
5	COST_CENTER	Character	8	ccent	Cost center	-
6	CHANGE_TYPE	Integer	6	2	Original/current	-
7	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
8	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
9	DATE_CHANGE	Date	8	-	Date of change	-
10	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per cost category / period (PRRCYP)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	YEAR	Integer	4	-	Year	-
5	PERIOD	Integer	3	-	Period	-
6	COST_CAT_CODE	Character	8	prccat	Cost category	-
7	COST_CENTER	Character	8	ccent	Cost center	-
8	CHANGE_TYPE	Integer	6	2	Original/current	-
9	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
10	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
11	DATE_CHANGE	Date	8	-	Date of change	-
12	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per employee (PRRHCA)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	EMPLOYEE_CODE	Character	8	premp	Employee	-
5	HOUR_CAT_CODE	Character	8	prhcat	Hour category	-
6	COST_CENTER	Character	8	ccent	Cost center	-
7	CHANGE_TYPE	Integer	6	2	Original/current	-
8	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
9	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
10	DATE_CHANGE	Date	8	-	Date of change	-
11	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per employee / period (PRRHYP)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	YEAR	Integer	4	-	Year	-
5	PERIOD	Integer	3	-	Period	-
6	EMPLOYEE_CODE	Character	8	premp	Employee	-
7	HOUR_CAT_CODE	Character	8	prhcat	Hour category	-
8	COST_CENTER	Character	8	ccent	Cost center	-
9	CHANGE_TYPE	Integer	6	2	Original/current	-
10	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
11	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
12	DATE_CHANGE	Date	8	-	Date of change	-
13	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per item (PRRITM)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	ITEM_CODE	Character	20	llitem	Item	-
5	COST_CAT_CODE	Character	8	prccat	Cost category	-
6	COST_CENTER	Character	8	ccent	Cost center	-
7	CHANGE_TYPE	Integer	6	2	Original/current	-
8	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
9	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
10	DATE_CHANGE	Date	8	-	Date of change	-
11	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per item / period (PRRIYP)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	YEAR	Integer	4	-	Year	-
5	PERIOD	Integer	3	-	Period	-
6	ITEM_CODE	Character	20	llitem	Item	-
7	COST_CAT_CODE	Character	8	prccat	Cost category	-
8	COST_CENTER	Character	8	ccent	Cost center	-
9	CHANGE_TYPE	Integer	6	2	Original/current	-
10	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
11	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
12	DATE_CHANGE	Date	8	-	Date of change	-
13	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per machinery (PRRMCH)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	MACHINERY_CODE	Character	8	prmach	Machinery	-
5	UNIT_CODE	Character	8	prunit	Unit	-
6	COST_CENTER	Character	8	ccent	Cost center	-
7	CHANGE_TYPE	Integer	6	2	Original/current	-
8	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
9	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
10	DATE_CHANGE	Date	8	-	Date of change	-
11	REASON_CHANGE	Character	30	-	Reason of change	-

Forecast per machinery / period (PRRMYP)

Nr	Field name	Data type	Field length	Ref	Description	Check/Action
1	ADM_NR	Integer	6	admdat	Company	-
2	PROJECT_CODE	Character	10	prmst	Project	-
3	RESULT_TYPE	Integer	6	1	Result type	-
4	YEAR	Integer	4	-	Year	-
5	PERIOD	Integer	3	-	Period	-
6	MACHINERY_CODE	Character	8	prmach	Employee	-
7	UNIT_CODE	Character	8	prunit	Machinery	-
8	COST_CENTER	Character	8	ccent	Cost center	-
9	CHANGE_TYPE	Integer	6	2	Original/current	-
10	BUDGET_QUANTITY	Decimal	15	-	Budget quantity	-
11	BUDGET_AMOUNT	Decimal	15	-	Budget amount	-
12	DATE_CHANGE	Date	8	-	Date of change	-
13	REASON_CHANGE	Character	30	-	Reason of change	-

400501: Expenses
400502: Revenues
403001: Original
403002: Current
403003: Actual forecast
403004: Estimate to complete
403005: Percentage completed

NOTE: Prior of version 3.24 the field "COST_CAT_CODE" has been available in the Exact definition for PRRHCA,PRRHYP,PRRMCH and PRRMYP. They have been removed since this data is filled from the masterdata of the empoyee or machine.

Connectivity Manual > Contents > IFALL > Project > Project forecasts

Main Category:	Support Product Know How	Document Type:	Support - On-line help
Category:	On-line help files	Security level:	All - 0
Sub category:	Details	Document ID:	18.330.357
Assortment:	Exact Financials	Date:	03-12-2008
Release:		Attachment:
Disclaimer

Tags	Support Product Know How-On-line help files-Details